解决Ubuntu20.04启动MySQL报错（Job for mysql.service failed because the control process exited with error）

您所在的位置：网站首页 › ensure failed报错3860 › 解决Ubuntu20.04启动MySQL报错（Job for mysql.service failed because the control process exited with error）

解决Ubuntu20.04启动MySQL报错（Job for mysql.service failed because the control process exited with error）

#解决Ubuntu20.04启动MySQL报错（Job for mysql.service failed because the control process exited with error）| 来源: 网络整理| 查看: 265

文章目录 mysql启动时报错情况0.Ubuntu下的mysql相关文件介绍1.修改文件权限2.测试（可选）3.重启mysql

运行环境：ubuntu20.04，mysql 8.0

mysql Ver 8.0.29-0ubuntu0.20.04.3 for Linux on x86_64 ((Ubuntu))

授人以鱼不如授人以渔：具体错误原因请到日志文件/var/log/mysql/error.log中排查（注意要放开日志文件的写入权限）

mysql启动时报错情况 sudo service mysql start # 启动

Job for mysql.service failed because the control process exited with error code. See “systemctl status mysql.service” and “journalctl -xe” for details.

sudo service mysql status # 查看状态；建议加上sudo，会有更详细的信息

● mysql.service - MySQL Community Server Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled) Active: failed (Result: exit-code) since Wed 2024-02-28 10:10:31 CST; 10min ago Process: 546126 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=1/FAILURE)

0.Ubuntu下的mysql相关文件介绍

（注意Centos等其他linux系统下的mysql相关文件路径与Ubuntu不一样）

配置文件：

/etc/mysql/mysql.conf.d/mysqld.cnf # 其中log_error对应的路径是ubuntu中mysql的日志存放位置（log_error = /var/log/mysql/error.log） /etc/mysql/my.cnf # 启动配置

日志文件：

/var/log/mysql/error.log # 由/etc/mysql/mysql.conf.d/mysqld.cnf中的log_error设置

数据文件：

/var/lib/mysql # 注意：/var/lib/mysql千万不要删！这是存放mysql数据文件的目录

运行时文件：

/var/run/mysqld /tmp/data 1.修改文件权限 # 可能需要创建/tmp/data、/var/run/mysqld【ubuntu18升级到20，需要增加/var/run/mysqld，并且需要sudo dpkg --configure -a】 sudo mkdir -p /var/run/mysqld /tmp/data sudo chown -R mysql:mysql /var/lib/mysql /var/log/mysql /var/run/mysqld /tmp/data sudo chmod -R 777 /var/lib/mysql /var/log/mysql /var/run/mysqld /tmp/data 2.测试（可选）

mysqld_safe测试启动服务端（无需用户名和密码）

# 启动；并写入日志（可查看日志报错信息） mysqld_safe --defaults-file=/etc/mysql/my.cnf # /etc/mysql/my.cnf是ubuntu下的mysql启动参数配置文件

注意，测试通过后，要关闭测试进程，否则报错。

客户端连接mysql服务端，mysql -u root -p

可能出现客户端报错：

ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)

tail -n50 /var/log/mysql/error.log找到日志报错：

[ERROR] InnoDB: Unable to lock ./ibdata1, error: 11， Could not open or create the system tablespace.

原因：之前启动的mysqld_safe进程占用

解决：找到其他占用端口的进程，kill

ps -ef | grep mysql

user0 618596 617876 0 13:17 pts/22 00:00:00 /bin/sh /usr/bin/mysqld_safe --defaults-file=/etc/mysql/my.cnf user0 618942 618596 0 13:17 pts/22 00:00:05 /usr/sbin/mysqld --defaults-file=/etc/mysql/my.cnf --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --log-error=/var/log/mysql/error.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306

kill -9 618596 618942 3.重启mysql

重启mysql服务端：

sudo service mysql restart

sudo service mysql status查看正确的启动状态，示例如下：

● mysql.service - MySQL Community Server Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled) Active: active (running) since Wed 2024-02-28 13:57:17 CST; 16min ago Process: 623015 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS) Main PID: 623049 (mysqld) Status: “Server is operational” Tasks: 38 (limit: 347383) Memory: 369.1M CGroup: /system.slice/mysql.service └─623049 /usr/sbin/mysqld

【本文地址】

解决Ubuntu20.04启动MySQL报错（Job for mysql.service failed because the control process exited with error）

解决Ubuntu20.04启动MySQL报错（Job for mysql.service failed because the control process exited with error）

今日新闻

推荐新闻